<%@page import="web09.shop.DBUtil"%><%@page import="java.sql.ResultSet"%><%@page import="java.sql.PreparedStatement"%><%@page import="java.sql.Connection"%><%@ page language="java" pageEncoding="UTF-8"%>    
              
      
    <%    DBUtil dbutil=new DBUtil();    Connection conn=dbutil.getCon();    //Connection conn = new DBUtil().getCon();    PreparedStatement pstmt1 = conn.prepareStatement("select count(*) from student");    ResultSet rs1 = pstmt1.executeQuery();    rs1.next();    int recordCount = rs1.getInt(1);     //记录总数    int pageSize = 10;                    //每页记录数    int start=1;                        //显示开始页    int end=10;                            //显示结束页    int pageCount = recordCount%pageSize==0 ? recordCount/pageSize : recordCount/pageSize+1;     int currPage = request.getParameter("p")==null ? 1 : Integer.parseInt(request.getParameter("p"));        currPage = currPage<1 ? 1 : currPage;    currPage = currPage>pageCount ? pageCount : currPage;        PreparedStatement pst = conn.prepareStatement("select * from student limit ?,?");    pst.setInt(1,currPage*pageSize-pageSize);    pst.setInt(2,pageSize);    ResultSet rs = pst.executeQuery();        while(rs.next()){    %>    
    <%    }    %>    
           
        
                 
ID
                 
姓名
                 
年龄
                 
专业
            
        
             
<%=rs.getInt(1) %>
             
<%=rs.getString(2) %>
             
<%=rs.getInt("age") %>
             
<%=rs.getString(4) %>
            
        
                   
              <%                                     if(currPage>=7){                      start=currPage-5;                      end=currPage+4;                  }                  if(start>(pageCount-10)){                      start=pageCount-9;                  }                  if(currPage>1){                          out.print(String.format("首页",1));                          out.print(String.format("<<上一页",currPage-1));                  }                                    for(int i=start;i<=end;i++){                      if(i>pageCount) break;                      String pageinfo=String.format("%d",i,i);                      if(i==currPage){                          pageinfo=String.format("%d",i);                      }                      out.print(pageinfo);                  }                                    if(currPage
          
           下一页>>",currPage+1));                      out.print(String.format("
           尾页",pageCount));                   }                                                  %>          
          
              
       
      

请根据自己的项目、包名、数据库信息进行修改